/*Code van de trigger*/
CREATE TRIGGER [dbo].[user_ins]
ON [dbo].[Users]
FOR INSERT
AS
DECLARE @userid int
SELECT @userid = i.[UserId] FROM inserted i
INSERT INTO dbo.[UsersIdols] (UserId, IdolId) 
	(SELECT @userid, 1)
	UNION
	(SELECT @userid, 2)
	UNION
	(SELECT @userid, 3)
	UNION
	(SELECT @userid, 4)
GO